Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 869 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 122.3 KiB |
| Average record size in memory | 144.1 B |
Variable types
| NUM | 17 |
|---|---|
| CAT | 1 |
Reproduction
| Analysis started | 2020-06-13 15:26:37.161043 |
|---|---|
| Analysis finished | 2020-06-13 15:27:52.104370 |
| Duration | 1 minute and 14.94 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
ZAT is highly correlated with df_index | High correlation |
df_index is highly correlated with ZAT | High correlation |
N_DESTINO is highly correlated with N_ORIGEN | High correlation |
N_ORIGEN is highly correlated with N_DESTINO | High correlation |
25-59 is highly correlated with 20-24 and 6 other fields | High correlation |
20-24 is highly correlated with 25-59 and 5 other fields | High correlation |
5-19 is highly correlated with 20-24 and 5 other fields | High correlation |
MEDIA is highly correlated with 20-24 and 5 other fields | High correlation |
NINGUNA is highly correlated with 20-24 and 5 other fields | High correlation |
SUPERIOR is highly correlated with 25-59 and 1 other fields | High correlation |
60+ is highly correlated with SUPERIOR | High correlation |
HOMBRE is highly correlated with 20-24 and 5 other fields | High correlation |
MUJER is highly correlated with 20-24 and 5 other fields | High correlation |
df_index has unique values | Unique |
ZAT has unique values | Unique |
N_ORIGEN has 177 (20.4%) zeros | Zeros |
N_DESTINO has 176 (20.3%) zeros | Zeros |
ESTRATO has 144 (16.6%) zeros | Zeros |
CUPOS has 752 (86.5%) zeros | Zeros |
PARQUEADEROS has 710 (81.7%) zeros | Zeros |
NINGUNA has 24 (2.8%) zeros | Zeros |
POSGRADO has 26 (3.0%) zeros | Zeros |
| Distinct count | 869 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 446.8124280782509 |
|---|---|
| Minimum | 0 |
| Maximum | 921 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Memory size | 6.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 46.4 |
| Q1 | 224 |
| median | 448 |
| Q3 | 666 |
| 95-th percentile | 849.6 |
| Maximum | 921 |
| Range | 921 |
| Interquartile range (IQR) | 442 |
Descriptive statistics
| Standard deviation | 258.2122078 |
|---|---|
| Coefficient of variation (CV) | 0.577898446 |
| Kurtosis | -1.169368386 |
| Mean | 446.8124281 |
| Median Absolute Deviation (MAD) | 221 |
| Skewness | 0.01336040031 |
| Sum | 388280 |
| Variance | 66673.54427 |
| Value | Count | Frequency (%) | |
| 921 | 1 | 0.1% | |
| 292 | 1 | 0.1% | |
| 305 | 1 | 0.1% | |
| 304 | 1 | 0.1% | |
| 303 | 1 | 0.1% | |
| 302 | 1 | 0.1% | |
| 301 | 1 | 0.1% | |
| 300 | 1 | 0.1% | |
| 299 | 1 | 0.1% | |
| 298 | 1 | 0.1% | |
| Other values (859) | 859 | 98.8% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.1% | |
| 1 | 1 | 0.1% | |
| 2 | 1 | 0.1% | |
| 3 | 1 | 0.1% | |
| 4 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 921 | 1 | 0.1% | |
| 919 | 1 | 0.1% | |
| 918 | 1 | 0.1% | |
| 917 | 1 | 0.1% | |
| 916 | 1 | 0.1% |
| Distinct count | 869 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 467.2819332566168 |
|---|---|
| Minimum | 1 |
| Maximum | 1141 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 47.4 |
| Q1 | 225 |
| median | 449 |
| Q3 | 667 |
| 95-th percentile | 1000.6 |
| Maximum | 1141 |
| Range | 1140 |
| Interquartile range (IQR) | 442 |
Descriptive statistics
| Standard deviation | 290.5735983 |
|---|---|
| Coefficient of variation (CV) | 0.621837862 |
| Kurtosis | -0.806822074 |
| Mean | 467.2819333 |
| Median Absolute Deviation (MAD) | 221 |
| Skewness | 0.3346302649 |
| Sum | 406068 |
| Variance | 84433.01604 |
| Value | Count | Frequency (%) | |
| 1141 | 1 | 0.1% | |
| 293 | 1 | 0.1% | |
| 306 | 1 | 0.1% | |
| 305 | 1 | 0.1% | |
| 304 | 1 | 0.1% | |
| 303 | 1 | 0.1% | |
| 302 | 1 | 0.1% | |
| 301 | 1 | 0.1% | |
| 300 | 1 | 0.1% | |
| 299 | 1 | 0.1% | |
| Other values (859) | 859 | 98.8% |
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.1% | |
| 2 | 1 | 0.1% | |
| 3 | 1 | 0.1% | |
| 4 | 1 | 0.1% | |
| 5 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 1141 | 1 | 0.1% | |
| 1070 | 1 | 0.1% | |
| 1069 | 1 | 0.1% | |
| 1068 | 1 | 0.1% | |
| 1067 | 1 | 0.1% |
| Distinct count | 690 |
|---|---|
| Unique (%) | 79.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 944.7838377589818 |
|---|---|
| Minimum | 0.0 |
| Maximum | 12494.83348649324 |
| Zeros | 177 |
| Zeros (%) | 20.4% |
| Memory size | 6.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 72.82267097 |
| median | 465.4952839 |
| Q3 | 1186.811789 |
| 95-th percentile | 3669.699451 |
| Maximum | 12494.83349 |
| Range | 12494.83349 |
| Interquartile range (IQR) | 1113.989118 |
Descriptive statistics
| Standard deviation | 1454.671114 |
|---|---|
| Coefficient of variation (CV) | 1.539686705 |
| Kurtosis | 17.51878753 |
| Mean | 944.7838378 |
| Median Absolute Deviation (MAD) | 465.4952839 |
| Skewness | 3.537384794 |
| Sum | 821017.155 |
| Variance | 2116068.051 |
| Value | Count | Frequency (%) | |
| 0 | 177 | 20.4% | |
| 156.5007965 | 2 | 0.2% | |
| 28.63251865 | 2 | 0.2% | |
| 192.1900338 | 2 | 0.2% | |
| 199.1705691 | 1 | 0.1% | |
| 767.0150787 | 1 | 0.1% | |
| 388.5127006 | 1 | 0.1% | |
| 124.7152068 | 1 | 0.1% | |
| 2727.341047 | 1 | 0.1% | |
| 4169.698737 | 1 | 0.1% | |
| Other values (680) | 680 | 78.3% |
| Value | Count | Frequency (%) | |
| 0 | 177 | 20.4% | |
| 2.835511132 | 1 | 0.1% | |
| 5.322238278 | 1 | 0.1% | |
| 14.07770981 | 1 | 0.1% | |
| 14.97771091 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 12494.83349 | 1 | 0.1% | |
| 12198.97985 | 1 | 0.1% | |
| 11355.91146 | 1 | 0.1% | |
| 10596.32379 | 1 | 0.1% | |
| 8703.699342 | 1 | 0.1% |
| Distinct count | 692 |
|---|---|
| Unique (%) | 79.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 940.166239917363 |
|---|---|
| Minimum | 0.0 |
| Maximum | 12327.549730943923 |
| Zeros | 176 |
| Zeros (%) | 20.3% |
| Memory size | 6.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 71.54733971 |
| median | 494.259481 |
| Q3 | 1213.179891 |
| 95-th percentile | 3438.564018 |
| Maximum | 12327.54973 |
| Range | 12327.54973 |
| Interquartile range (IQR) | 1141.632552 |
Descriptive statistics
| Standard deviation | 1430.842701 |
|---|---|
| Coefficient of variation (CV) | 1.521903936 |
| Kurtosis | 17.58564723 |
| Mean | 940.1662399 |
| Median Absolute Deviation (MAD) | 494.259481 |
| Skewness | 3.507784693 |
| Sum | 817004.4625 |
| Variance | 2047310.834 |
| Value | Count | Frequency (%) | |
| 0 | 176 | 20.3% | |
| 192.1900338 | 2 | 0.2% | |
| 388.5127006 | 2 | 0.2% | |
| 2202.325304 | 1 | 0.1% | |
| 120.0615076 | 1 | 0.1% | |
| 249.4304137 | 1 | 0.1% | |
| 1302.202649 | 1 | 0.1% | |
| 1612.805816 | 1 | 0.1% | |
| 837.5842286 | 1 | 0.1% | |
| 419.3209934 | 1 | 0.1% | |
| Other values (682) | 682 | 78.5% |
| Value | Count | Frequency (%) | |
| 0 | 176 | 20.3% | |
| 2.22393528 | 1 | 0.1% | |
| 2.835511132 | 1 | 0.1% | |
| 9.767766992 | 1 | 0.1% | |
| 14.01278085 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 12327.54973 | 1 | 0.1% | |
| 11916.572 | 1 | 0.1% | |
| 11520.85389 | 1 | 0.1% | |
| 10810.58531 | 1 | 0.1% | |
| 8002.286687 | 1 | 0.1% |
| Distinct count | 7 |
|---|---|
| Unique (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.486766398158803 |
|---|---|
| Minimum | 0.0 |
| Maximum | 6.0 |
| Zeros | 144 |
| Zeros (%) | 16.6% |
| Memory size | 6.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 3 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.594596945 |
|---|---|
| Coefficient of variation (CV) | 0.6412331074 |
| Kurtosis | -0.3073776538 |
| Mean | 2.486766398 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.1616909652 |
| Sum | 2161 |
| Variance | 2.542739417 |
| Value | Count | Frequency (%) | |
| 3 | 276 | 31.8% | |
| 2 | 197 | 22.7% | |
| 0 | 144 | 16.6% | |
| 4 | 100 | 11.5% | |
| 1 | 67 | 7.7% | |
| 6 | 47 | 5.4% | |
| 5 | 38 | 4.4% |
| Value | Count | Frequency (%) | |
| 0 | 144 | 16.6% | |
| 1 | 67 | 7.7% | |
| 2 | 197 | 22.7% | |
| 3 | 276 | 31.8% | |
| 4 | 100 | 11.5% |
| Value | Count | Frequency (%) | |
| 6 | 47 | 5.4% | |
| 5 | 38 | 4.4% | |
| 4 | 100 | 11.5% | |
| 3 | 276 | 31.8% | |
| 2 | 197 | 22.7% |
USO
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.8 KiB |
| RESIDENCIAL | |
|---|---|
| OTROS | 103 |
| BODEGAS | 21 |
| OFICINAS | 15 |
| UNIVERSIDADES Y COLEGIOS | 7 |
| Other values (3) | 10 |
| Value | Count | Frequency (%) | |
| RESIDENCIAL | 713 | 82.0% | |
| OTROS | 103 | 11.9% | |
| BODEGAS | 21 | 2.4% | |
| OFICINAS | 15 | 1.7% | |
| UNIVERSIDADES Y COLEGIOS | 7 | 0.8% | |
| COMERCIO | 7 | 0.8% | |
| INDUSTRIA | 2 | 0.2% | |
| CLINICAS, HOSPITALES, CENTROS MEDICOS | 1 | 0.1% |
Length
| Max length | 37 |
|---|---|
| Median length | 11 |
| Mean length | 10.24626007 |
| Min length | 5 |
| Distinct count | 77 |
|---|---|
| Unique (%) | 8.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.627157652474109 |
|---|---|
| Minimum | 0.0 |
| Maximum | 785.0 |
| Zeros | 752 |
| Zeros (%) | 86.5% |
| Memory size | 6.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 96 |
| Maximum | 785 |
| Range | 785 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 67.78208849 |
|---|---|
| Coefficient of variation (CV) | 4.337454705 |
| Kurtosis | 59.51133888 |
| Mean | 15.62715765 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.021085544 |
| Sum | 13580 |
| Variance | 4594.41152 |
| Value | Count | Frequency (%) | |
| 0 | 752 | 86.5% | |
| 12 | 15 | 1.7% | |
| 22 | 5 | 0.6% | |
| 48 | 4 | 0.5% | |
| 20 | 3 | 0.3% | |
| 38 | 3 | 0.3% | |
| 60 | 3 | 0.3% | |
| 50 | 2 | 0.2% | |
| 100 | 2 | 0.2% | |
| 15 | 2 | 0.2% | |
| Other values (67) | 78 | 9.0% |
| Value | Count | Frequency (%) | |
| 0 | 752 | 86.5% | |
| 12 | 15 | 1.7% | |
| 13 | 1 | 0.1% | |
| 14 | 2 | 0.2% | |
| 15 | 2 | 0.2% |
| Value | Count | Frequency (%) | |
| 785 | 1 | 0.1% | |
| 720 | 1 | 0.1% | |
| 710 | 1 | 0.1% | |
| 568 | 1 | 0.1% | |
| 532 | 1 | 0.1% |
| Distinct count | 13 |
|---|---|
| Unique (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.44994246260069043 |
|---|---|
| Minimum | 0.0 |
| Maximum | 15.0 |
| Zeros | 710 |
| Zeros (%) | 81.7% |
| Memory size | 6.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 3 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.369126541 |
|---|---|
| Coefficient of variation (CV) | 3.042892491 |
| Kurtosis | 36.09729195 |
| Mean | 0.4499424626 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.193863619 |
| Sum | 391 |
| Variance | 1.874507485 |
| Value | Count | Frequency (%) | |
| 0 | 710 | 81.7% | |
| 1 | 73 | 8.4% | |
| 2 | 36 | 4.1% | |
| 3 | 23 | 2.6% | |
| 4 | 7 | 0.8% | |
| 6 | 6 | 0.7% | |
| 5 | 5 | 0.6% | |
| 8 | 2 | 0.2% | |
| 9 | 2 | 0.2% | |
| 7 | 2 | 0.2% | |
| Other values (3) | 3 | 0.3% |
| Value | Count | Frequency (%) | |
| 0 | 710 | 81.7% | |
| 1 | 73 | 8.4% | |
| 2 | 36 | 4.1% | |
| 3 | 23 | 2.6% | |
| 4 | 7 | 0.8% |
| Value | Count | Frequency (%) | |
| 15 | 1 | 0.1% | |
| 13 | 1 | 0.1% | |
| 12 | 1 | 0.1% | |
| 9 | 2 | 0.2% | |
| 8 | 2 | 0.2% |
| Distinct count | 682 |
|---|---|
| Unique (%) | 78.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 868.5707710011508 |
|---|---|
| Minimum | 0.0 |
| Maximum | 7132.0 |
| Zeros | 3 |
| Zeros (%) | 0.3% |
| Memory size | 6.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 11.4 |
| Q1 | 203 |
| median | 536 |
| Q3 | 1175 |
| 95-th percentile | 2768.8 |
| Maximum | 7132 |
| Range | 7132 |
| Interquartile range (IQR) | 972 |
Descriptive statistics
| Standard deviation | 981.4787084 |
|---|---|
| Coefficient of variation (CV) | 1.129992789 |
| Kurtosis | 7.352009216 |
| Mean | 868.570771 |
| Median Absolute Deviation (MAD) | 402 |
| Skewness | 2.311946771 |
| Sum | 754788 |
| Variance | 963300.455 |
| Value | Count | Frequency (%) | |
| 4 | 12 | 1.4% | |
| 2 | 8 | 0.9% | |
| 1 | 6 | 0.7% | |
| 152 | 4 | 0.5% | |
| 414 | 4 | 0.5% | |
| 454 | 3 | 0.3% | |
| 0 | 3 | 0.3% | |
| 399 | 3 | 0.3% | |
| 13 | 3 | 0.3% | |
| 201 | 3 | 0.3% | |
| Other values (672) | 820 | 94.4% |
| Value | Count | Frequency (%) | |
| 0 | 3 | 0.3% | |
| 1 | 6 | 0.7% | |
| 2 | 8 | 0.9% | |
| 3 | 2 | 0.2% | |
| 4 | 12 | 1.4% |
| Value | Count | Frequency (%) | |
| 7132 | 1 | 0.1% | |
| 7029 | 1 | 0.1% | |
| 5771 | 1 | 0.1% | |
| 5734 | 1 | 0.1% | |
| 5509 | 1 | 0.1% |
| Distinct count | 818 |
|---|---|
| Unique (%) | 94.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4564.827387802071 |
|---|---|
| Minimum | 0.0 |
| Maximum | 35334.0 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Memory size | 6.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 69.6 |
| Q1 | 1168 |
| median | 3012 |
| Q3 | 6312 |
| 95-th percentile | 14592.8 |
| Maximum | 35334 |
| Range | 35334 |
| Interquartile range (IQR) | 5144 |
Descriptive statistics
| Standard deviation | 4839.297346 |
|---|---|
| Coefficient of variation (CV) | 1.060127127 |
| Kurtosis | 5.943113293 |
| Mean | 4564.827388 |
| Median Absolute Deviation (MAD) | 2214 |
| Skewness | 2.077523778 |
| Sum | 3966835 |
| Variance | 23418798.8 |
| Value | Count | Frequency (%) | |
| 21 | 4 | 0.5% | |
| 89 | 3 | 0.3% | |
| 3245 | 3 | 0.3% | |
| 1191 | 2 | 0.2% | |
| 475 | 2 | 0.2% | |
| 75 | 2 | 0.2% | |
| 2474 | 2 | 0.2% | |
| 4799 | 2 | 0.2% | |
| 1258 | 2 | 0.2% | |
| 2829 | 2 | 0.2% | |
| Other values (808) | 845 | 97.2% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.1% | |
| 4 | 1 | 0.1% | |
| 5 | 2 | 0.2% | |
| 6 | 1 | 0.1% | |
| 9 | 2 | 0.2% |
| Value | Count | Frequency (%) | |
| 35334 | 1 | 0.1% | |
| 29644 | 1 | 0.1% | |
| 29215 | 1 | 0.1% | |
| 27122 | 1 | 0.1% | |
| 26676 | 1 | 0.1% |
| Distinct count | 763 |
|---|---|
| Unique (%) | 87.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1856.7502876869964 |
|---|---|
| Minimum | 0.0 |
| Maximum | 16906.0 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Memory size | 6.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 35 |
| Q1 | 366 |
| median | 1052 |
| Q3 | 2548 |
| 95-th percentile | 5964.8 |
| Maximum | 16906 |
| Range | 16906 |
| Interquartile range (IQR) | 2182 |
Descriptive statistics
| Standard deviation | 2202.229226 |
|---|---|
| Coefficient of variation (CV) | 1.186066452 |
| Kurtosis | 8.427927685 |
| Mean | 1856.750288 |
| Median Absolute Deviation (MAD) | 841 |
| Skewness | 2.450172628 |
| Sum | 1613516 |
| Variance | 4849813.563 |
| Value | Count | Frequency (%) | |
| 2 | 7 | 0.8% | |
| 7 | 5 | 0.6% | |
| 46 | 4 | 0.5% | |
| 14 | 3 | 0.3% | |
| 35 | 3 | 0.3% | |
| 19 | 3 | 0.3% | |
| 57 | 3 | 0.3% | |
| 280 | 3 | 0.3% | |
| 228 | 3 | 0.3% | |
| 1 | 3 | 0.3% | |
| Other values (753) | 832 | 95.7% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.1% | |
| 1 | 3 | 0.3% | |
| 2 | 7 | 0.8% | |
| 4 | 2 | 0.2% | |
| 5 | 2 | 0.2% |
| Value | Count | Frequency (%) | |
| 16906 | 1 | 0.1% | |
| 15892 | 1 | 0.1% | |
| 12722 | 1 | 0.1% | |
| 12665 | 1 | 0.1% | |
| 12472 | 1 | 0.1% |
| Distinct count | 711 |
|---|---|
| Unique (%) | 81.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1170.14499424626 |
|---|---|
| Minimum | 0.0 |
| Maximum | 7654.0 |
| Zeros | 2 |
| Zeros (%) | 0.2% |
| Memory size | 6.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 13.4 |
| Q1 | 325 |
| median | 858 |
| Q3 | 1695 |
| 95-th percentile | 3385.2 |
| Maximum | 7654 |
| Range | 7654 |
| Interquartile range (IQR) | 1370 |
Descriptive statistics
| Standard deviation | 1102.997532 |
|---|---|
| Coefficient of variation (CV) | 0.9426161178 |
| Kurtosis | 2.992686669 |
| Mean | 1170.144994 |
| Median Absolute Deviation (MAD) | 619 |
| Skewness | 1.5105982 |
| Sum | 1016856 |
| Variance | 1216603.555 |
| Value | Count | Frequency (%) | |
| 2 | 9 | 1.0% | |
| 5 | 8 | 0.9% | |
| 23 | 5 | 0.6% | |
| 7 | 4 | 0.5% | |
| 1 | 4 | 0.5% | |
| 780 | 4 | 0.5% | |
| 4 | 4 | 0.5% | |
| 1428 | 4 | 0.5% | |
| 24 | 4 | 0.5% | |
| 35 | 4 | 0.5% | |
| Other values (701) | 819 | 94.2% |
| Value | Count | Frequency (%) | |
| 0 | 2 | 0.2% | |
| 1 | 4 | 0.5% | |
| 2 | 9 | 1.0% | |
| 3 | 3 | 0.3% | |
| 4 | 4 | 0.5% |
| Value | Count | Frequency (%) | |
| 7654 | 1 | 0.1% | |
| 5977 | 1 | 0.1% | |
| 5667 | 1 | 0.1% | |
| 5617 | 1 | 0.1% | |
| 5595 | 1 | 0.1% |
| Distinct count | 817 |
|---|---|
| Unique (%) | 94.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4968.350978135788 |
|---|---|
| Minimum | 0.0 |
| Maximum | 45419.0 |
| Zeros | 2 |
| Zeros (%) | 0.2% |
| Memory size | 6.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 52.4 |
| Q1 | 817 |
| median | 2717 |
| Q3 | 6939 |
| 95-th percentile | 16842 |
| Maximum | 45419 |
| Range | 45419 |
| Interquartile range (IQR) | 6122 |
Descriptive statistics
| Standard deviation | 6191.537257 |
|---|---|
| Coefficient of variation (CV) | 1.246195626 |
| Kurtosis | 8.206675264 |
| Mean | 4968.350978 |
| Median Absolute Deviation (MAD) | 2274 |
| Skewness | 2.465831841 |
| Sum | 4317497 |
| Variance | 38335133.61 |
| Value | Count | Frequency (%) | |
| 15 | 4 | 0.5% | |
| 3 | 4 | 0.5% | |
| 72 | 3 | 0.3% | |
| 726 | 3 | 0.3% | |
| 21 | 3 | 0.3% | |
| 30 | 3 | 0.3% | |
| 253 | 2 | 0.2% | |
| 3311 | 2 | 0.2% | |
| 2959 | 2 | 0.2% | |
| 101 | 2 | 0.2% | |
| Other values (807) | 841 | 96.8% |
| Value | Count | Frequency (%) | |
| 0 | 2 | 0.2% | |
| 3 | 4 | 0.5% | |
| 4 | 1 | 0.1% | |
| 5 | 2 | 0.2% | |
| 6 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 45419 | 1 | 0.1% | |
| 43611 | 1 | 0.1% | |
| 37672 | 1 | 0.1% | |
| 36081 | 1 | 0.1% | |
| 35471 | 1 | 0.1% |
| Distinct count | 342 |
|---|---|
| Unique (%) | 39.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 138.228998849252 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1034.0 |
| Zeros | 24 |
| Zeros (%) | 2.8% |
| Memory size | 6.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 37 |
| median | 93 |
| Q3 | 191 |
| 95-th percentile | 434 |
| Maximum | 1034 |
| Range | 1034 |
| Interquartile range (IQR) | 154 |
Descriptive statistics
| Standard deviation | 142.8258802 |
|---|---|
| Coefficient of variation (CV) | 1.03325555 |
| Kurtosis | 4.767976074 |
| Mean | 138.2289988 |
| Median Absolute Deviation (MAD) | 67 |
| Skewness | 1.893161917 |
| Sum | 120121 |
| Variance | 20399.23206 |
| Value | Count | Frequency (%) | |
| 0 | 24 | 2.8% | |
| 1 | 16 | 1.8% | |
| 2 | 11 | 1.3% | |
| 3 | 10 | 1.2% | |
| 4 | 9 | 1.0% | |
| 38 | 9 | 1.0% | |
| 13 | 9 | 1.0% | |
| 35 | 8 | 0.9% | |
| 74 | 8 | 0.9% | |
| 52 | 8 | 0.9% | |
| Other values (332) | 757 | 87.1% |
| Value | Count | Frequency (%) | |
| 0 | 24 | 2.8% | |
| 1 | 16 | 1.8% | |
| 2 | 11 | 1.3% | |
| 3 | 10 | 1.2% | |
| 4 | 9 | 1.0% |
| Value | Count | Frequency (%) | |
| 1034 | 1 | 0.1% | |
| 853 | 1 | 0.1% | |
| 798 | 1 | 0.1% | |
| 795 | 1 | 0.1% | |
| 730 | 1 | 0.1% |
| Distinct count | 534 |
|---|---|
| Unique (%) | 61.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 524.3325661680092 |
|---|---|
| Minimum | 0.0 |
| Maximum | 5160.0 |
| Zeros | 26 |
| Zeros (%) | 3.0% |
| Memory size | 6.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 52 |
| median | 207 |
| Q3 | 596 |
| 95-th percentile | 2364.8 |
| Maximum | 5160 |
| Range | 5160 |
| Interquartile range (IQR) | 544 |
Descriptive statistics
| Standard deviation | 801.0081356 |
|---|---|
| Coefficient of variation (CV) | 1.527671915 |
| Kurtosis | 7.547539893 |
| Mean | 524.3325662 |
| Median Absolute Deviation (MAD) | 190 |
| Skewness | 2.592524364 |
| Sum | 455645 |
| Variance | 641614.0333 |
| Value | Count | Frequency (%) | |
| 0 | 26 | 3.0% | |
| 1 | 13 | 1.5% | |
| 3 | 10 | 1.2% | |
| 4 | 9 | 1.0% | |
| 5 | 9 | 1.0% | |
| 2 | 9 | 1.0% | |
| 8 | 8 | 0.9% | |
| 10 | 7 | 0.8% | |
| 11 | 7 | 0.8% | |
| 6 | 6 | 0.7% | |
| Other values (524) | 765 | 88.0% |
| Value | Count | Frequency (%) | |
| 0 | 26 | 3.0% | |
| 1 | 13 | 1.5% | |
| 2 | 9 | 1.0% | |
| 3 | 10 | 1.2% | |
| 4 | 9 | 1.0% |
| Value | Count | Frequency (%) | |
| 5160 | 1 | 0.1% | |
| 4856 | 1 | 0.1% | |
| 4642 | 1 | 0.1% | |
| 4464 | 1 | 0.1% | |
| 4437 | 1 | 0.1% |
| Distinct count | 790 |
|---|---|
| Unique (%) | 90.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2633.9113924050635 |
|---|---|
| Minimum | 0.0 |
| Maximum | 21871.0 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Memory size | 6.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 33 |
| Q1 | 671 |
| median | 1744 |
| Q3 | 3634 |
| 95-th percentile | 8664 |
| Maximum | 21871 |
| Range | 21871 |
| Interquartile range (IQR) | 2963 |
Descriptive statistics
| Standard deviation | 2837.499961 |
|---|---|
| Coefficient of variation (CV) | 1.077295147 |
| Kurtosis | 6.70029891 |
| Mean | 2633.911392 |
| Median Absolute Deviation (MAD) | 1266 |
| Skewness | 2.130007367 |
| Sum | 2288869 |
| Variance | 8051406.03 |
| Value | Count | Frequency (%) | |
| 6 | 5 | 0.6% | |
| 3 | 5 | 0.6% | |
| 2 | 4 | 0.5% | |
| 4 | 3 | 0.3% | |
| 11 | 3 | 0.3% | |
| 22 | 3 | 0.3% | |
| 57 | 3 | 0.3% | |
| 1371 | 3 | 0.3% | |
| 1849 | 3 | 0.3% | |
| 615 | 2 | 0.2% | |
| Other values (780) | 835 | 96.1% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.1% | |
| 1 | 2 | 0.2% | |
| 2 | 4 | 0.5% | |
| 3 | 5 | 0.6% | |
| 4 | 3 | 0.3% |
| Value | Count | Frequency (%) | |
| 21871 | 1 | 0.1% | |
| 20743 | 1 | 0.1% | |
| 17605 | 1 | 0.1% | |
| 15895 | 1 | 0.1% | |
| 14256 | 1 | 0.1% |
| Distinct count | 823 |
|---|---|
| Unique (%) | 94.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4280.853855005754 |
|---|---|
| Minimum | 0.0 |
| Maximum | 32453.0 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Memory size | 6.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 68.8 |
| Q1 | 1083 |
| median | 2785 |
| Q3 | 6045 |
| 95-th percentile | 12987 |
| Maximum | 32453 |
| Range | 32453 |
| Interquartile range (IQR) | 4962 |
Descriptive statistics
| Standard deviation | 4560.571956 |
|---|---|
| Coefficient of variation (CV) | 1.065341661 |
| Kurtosis | 6.115608155 |
| Mean | 4280.853855 |
| Median Absolute Deviation (MAD) | 2105 |
| Skewness | 2.105020196 |
| Sum | 3720062 |
| Variance | 20798816.57 |
| Value | Count | Frequency (%) | |
| 19 | 5 | 0.6% | |
| 1370 | 3 | 0.3% | |
| 91 | 3 | 0.3% | |
| 1331 | 2 | 0.2% | |
| 15 | 2 | 0.2% | |
| 977 | 2 | 0.2% | |
| 1450 | 2 | 0.2% | |
| 62 | 2 | 0.2% | |
| 2500 | 2 | 0.2% | |
| 2015 | 2 | 0.2% | |
| Other values (813) | 844 | 97.1% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.1% | |
| 5 | 2 | 0.2% | |
| 6 | 2 | 0.2% | |
| 7 | 1 | 0.1% | |
| 8 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 32453 | 1 | 0.1% | |
| 30388 | 1 | 0.1% | |
| 25670 | 1 | 0.1% | |
| 25474 | 1 | 0.1% | |
| 25056 | 1 | 0.1% |
| Distinct count | 820 |
|---|---|
| Unique (%) | 94.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4697.983889528194 |
|---|---|
| Minimum | 0.0 |
| Maximum | 35785.0 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Memory size | 6.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 64 |
| Q1 | 1164 |
| median | 3103 |
| Q3 | 6609 |
| 95-th percentile | 14409.2 |
| Maximum | 35785 |
| Range | 35785 |
| Interquartile range (IQR) | 5445 |
Descriptive statistics
| Standard deviation | 4974.68218 |
|---|---|
| Coefficient of variation (CV) | 1.058897241 |
| Kurtosis | 5.788533531 |
| Mean | 4697.98389 |
| Median Absolute Deviation (MAD) | 2306 |
| Skewness | 2.051922371 |
| Sum | 4082548 |
| Variance | 24747462.79 |
| Value | Count | Frequency (%) | |
| 17 | 4 | 0.5% | |
| 31 | 3 | 0.3% | |
| 8 | 3 | 0.3% | |
| 64 | 3 | 0.3% | |
| 660 | 3 | 0.3% | |
| 15 | 3 | 0.3% | |
| 160 | 3 | 0.3% | |
| 47 | 2 | 0.2% | |
| 1462 | 2 | 0.2% | |
| 18 | 2 | 0.2% | |
| Other values (810) | 841 | 96.8% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.1% | |
| 3 | 1 | 0.1% | |
| 4 | 1 | 0.1% | |
| 6 | 1 | 0.1% | |
| 7 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 35785 | 1 | 0.1% | |
| 31499 | 1 | 0.1% | |
| 27757 | 1 | 0.1% | |
| 27386 | 1 | 0.1% | |
| 27258 | 1 | 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | ZAT | N_ORIGEN | N_DESTINO | ESTRATO | USO | CUPOS | PARQUEADEROS | 20-24 | 25-59 | 5-19 | 60+ | MEDIA | NINGUNA | POSGRADO | SUPERIOR | HOMBRE | MUJER | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 1 | 72.822671 | 72.822671 | 5.0 | RESIDENCIAL | 0.0 | 0.0 | 40.0 | 211.0 | 92.0 | 75.0 | 153.0 | 1.0 | 77.0 | 170.0 | 203.0 | 230.0 |
| 1 | 1 | 2 | 0.000000 | 0.000000 | 6.0 | RESIDENCIAL | 0.0 | 0.0 | 15.0 | 141.0 | 80.0 | 32.0 | 100.0 | 4.0 | 41.0 | 118.0 | 130.0 | 147.0 |
| 2 | 2 | 3 | 0.000000 | 0.000000 | 6.0 | OTROS | 0.0 | 0.0 | 34.0 | 180.0 | 63.0 | 58.0 | 128.0 | 2.0 | 26.0 | 114.0 | 172.0 | 176.0 |
| 3 | 3 | 4 | 0.000000 | 0.000000 | 0.0 | OTROS | 164.0 | 0.0 | 8.0 | 30.0 | 6.0 | 13.0 | 11.0 | 2.0 | 7.0 | 27.0 | 31.0 | 26.0 |
| 4 | 4 | 5 | 0.000000 | 0.000000 | 4.0 | OTROS | 0.0 | 0.0 | 4.0 | 21.0 | 7.0 | 2.0 | 15.0 | 0.0 | 0.0 | 3.0 | 19.0 | 17.0 |
| 5 | 6 | 7 | 460.092441 | 433.870206 | 2.0 | COMERCIO | 0.0 | 2.0 | 199.0 | 933.0 | 391.0 | 158.0 | 1065.0 | 30.0 | 17.0 | 508.0 | 880.0 | 918.0 |
| 6 | 7 | 8 | 0.000000 | 0.000000 | 0.0 | OTROS | 0.0 | 0.0 | 50.0 | 237.0 | 86.0 | 67.0 | 167.0 | 8.0 | 63.0 | 174.0 | 230.0 | 225.0 |
| 7 | 8 | 9 | 1525.677570 | 1347.161930 | 4.0 | RESIDENCIAL | 720.0 | 3.0 | 1830.0 | 9905.0 | 2836.0 | 3196.0 | 5414.0 | 226.0 | 2582.0 | 9184.0 | 8472.0 | 9972.0 |
| 8 | 9 | 10 | 0.000000 | 0.000000 | 0.0 | BODEGAS | 0.0 | 0.0 | 259.0 | 1233.0 | 413.0 | 606.0 | 638.0 | 33.0 | 429.0 | 1285.0 | 1197.0 | 1376.0 |
| 9 | 10 | 11 | 4731.699285 | 4751.436823 | 3.0 | RESIDENCIAL | 0.0 | 0.0 | 2880.0 | 14412.0 | 5171.0 | 3475.0 | 14590.0 | 358.0 | 1504.0 | 8712.0 | 13051.0 | 14387.0 |
Last rows
| df_index | ZAT | N_ORIGEN | N_DESTINO | ESTRATO | USO | CUPOS | PARQUEADEROS | 20-24 | 25-59 | 5-19 | 60+ | MEDIA | NINGUNA | POSGRADO | SUPERIOR | HOMBRE | MUJER | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 859 | 901 | 1052 | 0.000000 | 0.000000 | 0.0 | OTROS | 0.0 | 0.0 | 17.0 | 68.0 | 43.0 | 9.0 | 101.0 | 4.0 | 1.0 | 26.0 | 65.0 | 88.0 |
| 860 | 902 | 1053 | 0.000000 | 0.000000 | 0.0 | OTROS | 0.0 | 0.0 | 2.0 | 27.0 | 14.0 | 4.0 | 22.0 | 0.0 | 0.0 | 4.0 | 24.0 | 29.0 |
| 861 | 908 | 1059 | 0.000000 | 0.000000 | 0.0 | OTROS | 0.0 | 0.0 | 4.0 | 21.0 | 7.0 | 2.0 | 15.0 | 0.0 | 0.0 | 3.0 | 19.0 | 17.0 |
| 862 | 912 | 1063 | 0.000000 | 0.000000 | 4.0 | OTROS | 0.0 | 0.0 | 4.0 | 21.0 | 7.0 | 2.0 | 15.0 | 0.0 | 0.0 | 3.0 | 19.0 | 17.0 |
| 863 | 914 | 1065 | 90.341337 | 90.341337 | 0.0 | OTROS | 0.0 | 0.0 | 127.0 | 557.0 | 284.0 | 81.0 | 751.0 | 16.0 | 9.0 | 235.0 | 553.0 | 591.0 |
| 864 | 916 | 1067 | 0.000000 | 0.000000 | 2.0 | RESIDENCIAL | 0.0 | 0.0 | 4.0 | 89.0 | 46.0 | 5.0 | 72.0 | 1.0 | 4.0 | 57.0 | 91.0 | 64.0 |
| 865 | 917 | 1068 | 0.000000 | 0.000000 | 0.0 | OTROS | 0.0 | 0.0 | 2.0 | 75.0 | 35.0 | 2.0 | 51.0 | 1.0 | 4.0 | 49.0 | 76.0 | 49.0 |
| 866 | 918 | 1069 | 0.000000 | 0.000000 | 0.0 | UNIVERSIDADES Y COLEGIOS | 0.0 | 0.0 | 25.0 | 261.0 | 167.0 | 31.0 | 189.0 | 3.0 | 107.0 | 172.0 | 243.0 | 266.0 |
| 867 | 919 | 1070 | 39.686473 | 39.686473 | 6.0 | UNIVERSIDADES Y COLEGIOS | 0.0 | 0.0 | 163.0 | 1034.0 | 604.0 | 108.0 | 680.0 | 39.0 | 423.0 | 596.0 | 977.0 | 1042.0 |
| 868 | 921 | 1141 | 0.000000 | 0.000000 | 1.0 | RESIDENCIAL | 0.0 | 0.0 | 550.0 | 2095.0 | 1173.0 | 316.0 | 3311.0 | 111.0 | 11.0 | 512.0 | 2149.0 | 2352.0 |